IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'spTdoctypes_Update')
	BEGIN
		PRINT 'Dropping Procedure spTdoctypes_Update'
		DROP  Procedure  spTdoctypes_Update
	END

GO

PRINT 'Creating Procedure spTdoctypes_Update'
GO
Create Procedure dbo.spTdoctypes_Update
	( 	  
		@doctype char(50), 
		@mandatory bit = null, 
		@useqc bit = null, 
		@initreq int = null, 
		@dispseq int = null, 
		@tooltip varchar(100) = null, 
		@barcode char(20) = null, 
		@istd bit = null, 
		@ismb bit = null, 
		@isrelease bit = null, 
		@containername varchar(50) = null
	)
AS
  /* 
    ------------------------------------------------------------------------------
    - Change History
    - --------------
    - Date          Description
    ------------------------------------------------------------------------------
    - 8/22/2007    Initial version Updated
    ------------------------------------------------------------------------------
  */

	-- Declare the required variables

	-- Update the required new record
	UPDATE Tdoctypes
	SET
		mandatory = @mandatory, 
		useqc = @useqc, 
		initreq = @initreq, 
		dispseq = @dispseq, 
		tooltip = @tooltip, 
		barcode = @barcode, 
		istd = @istd, 
		ismb = @ismb, 
		isrelease = @isrelease, 
		containername = @containername		
	WHERE doctype = @doctype

	-- Return to calling method
	RETURN
	
GO
